prepare("insert into expensis(expdate,department,amount,aims,purpose,admin) values(:a,:b,:c,:am,:d,:e)") ; $query->bindparam(":a",$edate) ; $query->bindparam(":b",$dept) ; $query->bindparam(":c",$amt) ; $query->bindparam(":am",$aims) ; $query->bindparam(":d",$ds) ; $query->bindparam(":e",$adm) ; if($query->execute()) $mos = "Expensis Submitted Successfully" ; } //} ?> EXPENSIS

ENTER EXPENSIS

prepare("select * from expensis ") ; $gtcat->execute() ; $count = 0 ; while($row = $gtcat->fetch(pdo::FETCH_ASSOC)) { $count++ ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } ?>
SN DATE DEPARTMENT PURPOSE AMOUNT ACTIONS
".$count."".$row['expdate']."".$row['department']."".$row['purpose']."".$row['amount']."DELETE